﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using QLTV_Public;

namespace QLTV_Data
{
   public class Reports_Data
    {
       KetNoiCSDL_Data kn = new KetNoiCSDL_Data();
       public DataTable InPhieuMuon_GiaoVien(string maPhieuYC)
       {
           int Npara = 1;
           string[] name = new string[Npara];
           object[] value = new object[Npara];

           name[0] = "@MaPhieuYC";
           value[0] = maPhieuYC;

           return kn.LayDuLieu("InPhieuMuon_GiaoVien",name,value,Npara);
       }
       public DataTable InPhieuMuon_HocVien(string maPhieuYC)
       {
           int Npara = 1;
           string[] name = new string[Npara];
           object[] value = new object[Npara];

           name[0] = "@MaPhieuYC";
           value[0] = maPhieuYC;

           return kn.LayDuLieu("InPhieuMuon_HocVien", name, value, Npara);
       }
       public DataTable InMaCaBiet(string soCaBiet)
       {
           int Npara = 1;
           string[] name = new string[Npara];
           object[] value = new object[Npara];

           name[0] = "@SoCaBiet";
           value[0] = soCaBiet;

           return kn.LayDuLieu("InMaCaBiet", name, value, Npara);
       }
    }
}
